how to speed up report?? collections or arrays

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: how to speed up report?? collections or arrays

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5.2

Reproducible: Always

Hello Everyone:

I running a report which is taking for ever. I did not design the report and I am assuming it was creates some time ago because of the way it is coded. I added some new information to the database and it requires me to re-write the report or to modify it so I went with the modification but it is taking too long.

The report used to collect information only from one form and now it needs to use two. the two forms are employment and members. The report collects all the matches from the employment form using the getalldocumentsbykey and puts them into a collection. I cycle through the collectiong getting all the member ID numbers and putting them into an array. After that I take the array and using a for loop search for each one of the member records by key. If I find the member record then I add it to a collection just in case that the criteria also includes things like gender, city, etc.
When the employment information was all inside the member record it use to do a ftsearch to get the records and it was fast but now it takes more than 5 minutes in some cases and the users are not happy.
I do not put all the code in here because it is about 2 or 3 pages but if anyone needs to see parts of it I can post any part of it.

I am not sure if the problem are the collections that it takes too long to go one by one to see if it matches the criteria or if it is because of the arrays and taking one value in the array and do a getdocumentbykey to find the document and check the criteria. I am sure there are lost of programmers out there with way more experience than me that will know what is best to use. I am searching between 40 and 50 thousand records everytime.

Thanks

Mynor de Paz

Feedback number WEBB9EWRW6 created by ~Sean Nonjipyterynds on 12/31/2013

Status: Open
Comments: